class CreateUserCfgs < ActiveRecord::Migration
  def self.up
    create_table :user_cfgs do |t|
      t.integer :user_sign
      t.string :sid,:null => false      
      t.string :nickname
      t.string :phone
      t.string :qq
      t.string :sex,:null => false,:default => '1'
      t.string :password
      t.string :img_style,:null => false,:default => '1'      
      t.string :pp_style,:null => false,:default => '1'
      t.integer :pp_num,:null => false,:default => 2
      t.string :user_type,:null => false,:default => '0'
      #导出时间
      t.datetime :click_date
      #导出状态 0 未导出 1已导出
      t.string :guide_status ,:null => false,:default => '0'
      #点击次数
      t.integer :click_num,:null => false,:default => 0
      t.timestamps
    end
  end

  def self.down
    drop_table :user_cfgs
  end
end
